USE [influenza]
GO

/****** Object:  Table [dbo].[dat_registro]    Script Date: 01/08/2010 17:38:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[dat_registro_del](
	[id_principal] [bigint] NULL,
	[id_generales] [bigint] NULL,
	[id_sector] [smallint] NULL,
	[id_unidad] [bigint] NULL,
	[nTipoPaciente] [smallint] NULL,
	[id_servicio] [smallint] NULL,
	[fIngreso] [datetime] NULL,
	[fSintoma_inicial] [datetime] NULL,
	[nDiagnostico] [smallint] NULL,
	[nContactoOtros] [smallint] NULL,
	[nVacunado] [smallint] NULL,
	[fVacuna_h1n1] [datetime] NULL,
	[fVacuna_estacional] [datetime] NULL,
	[nVacuna_desconoce] [smallint] NULL,
	[nContactoAves] [smallint] NULL,
	[nContactoCerdos] [smallint] NULL,
	[cContactoAnimales] [varchar](100) NULL,
	[nViajo] [smallint] NULL,
	[nRecibioTratamiento] [smallint] NULL,
	[nTratamiento_Antimicrobianos] [smallint] NULL,
	[nTratamiento_Antiviral] [smallint] NULL,
	[nAntiviral] [smallint] NULL,
	[cOtros_Antiviral] [varchar](150) NULL,
	[nTomaMuestra] [smallint] NULL,
	[nLabResultado] [smallint] NULL,
	[nCaso_clinico] [smallint] NULL,
	[nEvolucion] [smallint] NULL,
	[nsubevolucion] [smallint] NULL,
	[nIntubacion] [smallint] NULL,
	[fegreso] [smalldatetime] NULL,
	[nHorEgresoUrgencias] [smallint] NULL,
	[nUnidadReferir] [int] NULL,
	[cCertificadoDefuncion] [varchar](50) NULL,
	[nDclinico] [smallint] NULL,
	[cFolio] [varchar](20) NULL,
	[nOrigenDatos] [smallint] NULL,
	[nStatus] [smallint] NULL,
	[fCreacion] [nvarchar](50) NULL,
	[fModificacion] [nvarchar](50) NULL,
	[id_usuario] [int] NULL)